Using iMISFind to Retrieve iMIS Records

The iMISFind application is a Visual Basic executable file that allows users to log on to the iMIS database, and retrieve records to import into the EXPOCAD Exhibitor Database.

iMISFind window

Start> Programs> iMISFind

Search on

This is a drop-down list of search options.

Exhibitor Id – Searches on Name.ID

Name – Searches on Name.LAST_FIRST

Company/Institute – Searches on Name.COMPANY_SORT

Prospect on Event – Searches on Activity Type = ‘EX-PRO’ and exposition code equal to that of the event selected

Member Type – Searches on Name.MEMBER_TYPE

equal

You can enter a search qualifier, for example, if you Search on by Name or Company, you can enter an alphabetic character and the system returns a list of all the last names in database that begin with that character.

Display area

This is where the information found displays

Select All button

Highlights to select all the information in the list display area

Deselect All button

Deselects all the information highlighted

Export button

Exports the selected records into the Exhibitor List in EXPOCAD

Find button

Searches the iMIS database for records that meet the search criteria

Close button

Closes the iMISFind window

The following fields are exported from iMIS into EXPOCAD

iMIS Field

EXPOCAD Field

Name.ID

Exhibitor #

Name.Member_Type

Group

Name.COMPANY or Name.FULL_NAME

Name

Name.COMPANY or Name.FULL_NAME

Displayed on Drawing

iMISFind menu commands

■    File> Exit – closes the iMISFind Application

■    Edit> Cut – deletes the value in equal field

■    Edit>Copy – copies the value in equal field

■    Edit>Paste – pastes a copied value into equal field

■    iMIS Find – Opens the iMISFind window – reopens the window once the Close button has been clicked

■    Administrator> Pack ExpoCadExp – allows you to physically remove the deleted records from the database.

You must have exclusive access to the file as well as an Exposition Management authorization level of 8 or higher in order to run this option. It is recommended that an administrator occasionally run this option to remove the deleted records from the ExpoCadExp file. This will prevent the ExpoCadExp file from getting too large.